Overview
Brought to you by YData
Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 6019 |
| Missing cells | 5311 |
| Missing cells (%) | 6.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 658.5 KiB |
| Average record size in memory | 112.0 B |
Variable types
| Numeric | 5 |
|---|---|
| Text | 5 |
| Categorical | 4 |
Kilometers_Driven is highly overall correlated with Year | High correlation |
Price is highly overall correlated with Transmission | High correlation |
Transmission is highly overall correlated with Price | High correlation |
Year is highly overall correlated with Kilometers_Driven | High correlation |
Fuel_Type is highly imbalanced (53.4%) | Imbalance |
Owner_Type is highly imbalanced (60.9%) | Imbalance |
New_Price has 5195 (86.3%) missing values | Missing |
Kilometers_Driven is highly skewed (γ1 = 58.72466189) | Skewed |
Unnamed: 0 is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
Reproduction
| Analysis started | 2025-09-24 12:34:09.870277 |
|---|---|
| Analysis finished | 2025-09-24 12:34:13.059710 |
| Duration | 3.19 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
Unnamed: 0
Real number (ℝ)
Uniform Unique
| Distinct | 6019 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3009 |
| Minimum | 0 |
|---|---|
| Maximum | 6018 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 47.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 300.9 |
| Q1 | 1504.5 |
| median | 3009 |
| Q3 | 4513.5 |
| 95-th percentile | 5717.1 |
| Maximum | 6018 |
| Range | 6018 |
| Interquartile range (IQR) | 3009 |
Descriptive statistics
| Standard deviation | 1737.68 |
|---|---|
| Coefficient of variation (CV) | 0.57749417 |
| Kurtosis | -1.2 |
| Mean | 3009 |
| Median Absolute Deviation (MAD) | 1505 |
| Skewness | 0 |
| Sum | 18111171 |
| Variance | 3019531.7 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 6018 | 1 | < 0.1% |
| 0 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 5979 | 1 | < 0.1% |
| 5980 | 1 | < 0.1% |
| 5981 | 1 | < 0.1% |
| 5982 | 1 | < 0.1% |
| 5983 | 1 | < 0.1% |
| 5984 | 1 | < 0.1% |
| 5985 | 1 | < 0.1% |
| Other values (6009) | 6009 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 6018 | 1 | |
| 6017 | 1 | |
| 6016 | 1 | |
| 6015 | 1 | |
| 6014 | 1 | |
| 6013 | 1 | |
| 6012 | 1 | |
| 6011 | 1 | |
| 6010 | 1 | |
| 6009 | 1 |
Name
Text
| Distinct | 1876 |
|---|---|
| Distinct (%) | 31.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 47.2 KiB |
Length
| Max length | 59 |
|---|---|
| Median length | 48 |
| Mean length | 26.161987 |
| Min length | 11 |
Unique
| Unique | 842 ? |
|---|---|
| Unique (%) | 14.0% |
Sample
| 1st row | Maruti Wagon R LXI CNG |
|---|---|
| 2nd row | Hyundai Creta 1.6 CRDi SX Option |
| 3rd row | Honda Jazz V |
| 4th row | Maruti Ertiga VDI |
| 5th row | Audi A4 New 2.0 TDI Multitronic |
| Value | Count | Frequency (%) |
| maruti | 1211 | 4.2% |
| hyundai | 1107 | 3.8% |
| honda | 608 | 2.1% |
| at | 548 | 1.9% |
| diesel | 506 | 1.7% |
| 1.2 | 419 | 1.4% |
| toyota | 411 | 1.4% |
| tdi | 392 | 1.3% |
| swift | 353 | 1.2% |
| mt | 339 | 1.2% |
| Other values (862) | 23226 |
Most occurring characters
| Value | Count | Frequency (%) |
| 23101 | 14.7% | |
| a | 9788 | 6.2% |
| i | 9460 | 6.0% |
| e | 7731 | 4.9% |
| t | 6582 | 4.2% |
| o | 6572 | 4.2% |
| n | 6501 | 4.1% |
| r | 6372 | 4.0% |
| u | 4347 | 2.8% |
| d | 4099 | 2.6% |
| Other values (59) | 72916 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 157469 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 23101 | 14.7% | |
| a | 9788 | 6.2% |
| i | 9460 | 6.0% |
| e | 7731 | 4.9% |
| t | 6582 | 4.2% |
| o | 6572 | 4.2% |
| n | 6501 | 4.1% |
| r | 6372 | 4.0% |
| u | 4347 | 2.8% |
| d | 4099 | 2.6% |
| Other values (59) | 72916 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 157469 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 23101 | 14.7% | |
| a | 9788 | 6.2% |
| i | 9460 | 6.0% |
| e | 7731 | 4.9% |
| t | 6582 | 4.2% |
| o | 6572 | 4.2% |
| n | 6501 | 4.1% |
| r | 6372 | 4.0% |
| u | 4347 | 2.8% |
| d | 4099 | 2.6% |
| Other values (59) | 72916 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 157469 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 23101 | 14.7% | |
| a | 9788 | 6.2% |
| i | 9460 | 6.0% |
| e | 7731 | 4.9% |
| t | 6582 | 4.2% |
| o | 6572 | 4.2% |
| n | 6501 | 4.1% |
| r | 6372 | 4.0% |
| u | 4347 | 2.8% |
| d | 4099 | 2.6% |
| Other values (59) | 72916 |
Location
Categorical
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 47.2 KiB |
| Mumbai | |
|---|---|
| Hyderabad | |
| Kochi | |
| Coimbatore | |
| Pune | |
| Other values (6) |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 6.8466523 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Mumbai |
|---|---|
| 2nd row | Pune |
| 3rd row | Chennai |
| 4th row | Chennai |
| 5th row | Coimbatore |
Common Values
| Value | Count | Frequency (%) |
| Mumbai | 790 | |
| Hyderabad | 742 | |
| Kochi | 651 | |
| Coimbatore | 636 | |
| Pune | 622 | |
| Delhi | 554 | |
| Kolkata | 535 | |
| Chennai | 494 | |
| Jaipur | 413 | |
| Bangalore | 358 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| mumbai | 790 | |
| hyderabad | 742 | |
| kochi | 651 | |
| coimbatore | 636 | |
| pune | 622 | |
| delhi | 554 | |
| kolkata | 535 | |
| chennai | 494 | |
| jaipur | 413 | |
| bangalore | 358 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 6051 | |
| e | 3630 | 8.8% |
| i | 3538 | 8.6% |
| o | 2816 | 6.8% |
| b | 2392 | 5.8% |
| r | 2149 | 5.2% |
| n | 1968 | 4.8% |
| d | 1932 | 4.7% |
| h | 1923 | 4.7% |
| u | 1825 | 4.4% |
| Other values (17) | 12986 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 41210 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 6051 | |
| e | 3630 | 8.8% |
| i | 3538 | 8.6% |
| o | 2816 | 6.8% |
| b | 2392 | 5.8% |
| r | 2149 | 5.2% |
| n | 1968 | 4.8% |
| d | 1932 | 4.7% |
| h | 1923 | 4.7% |
| u | 1825 | 4.4% |
| Other values (17) | 12986 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 41210 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 6051 | |
| e | 3630 | 8.8% |
| i | 3538 | 8.6% |
| o | 2816 | 6.8% |
| b | 2392 | 5.8% |
| r | 2149 | 5.2% |
| n | 1968 | 4.8% |
| d | 1932 | 4.7% |
| h | 1923 | 4.7% |
| u | 1825 | 4.4% |
| Other values (17) | 12986 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 41210 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 6051 | |
| e | 3630 | 8.8% |
| i | 3538 | 8.6% |
| o | 2816 | 6.8% |
| b | 2392 | 5.8% |
| r | 2149 | 5.2% |
| n | 1968 | 4.8% |
| d | 1932 | 4.7% |
| h | 1923 | 4.7% |
| u | 1825 | 4.4% |
| Other values (17) | 12986 |
Year
Real number (ℝ)
High correlation
| Distinct | 22 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2013.3582 |
| Minimum | 1998 |
|---|---|
| Maximum | 2019 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 47.2 KiB |
Quantile statistics
| Minimum | 1998 |
|---|---|
| 5-th percentile | 2007 |
| Q1 | 2011 |
| median | 2014 |
| Q3 | 2016 |
| 95-th percentile | 2018 |
| Maximum | 2019 |
| Range | 21 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.2697421 |
|---|---|
| Coefficient of variation (CV) | 0.001624024 |
| Kurtosis | 0.89420088 |
| Mean | 2013.3582 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.84580214 |
| Sum | 12118403 |
| Variance | 10.691214 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=22)
| Value | Count | Frequency (%) |
| 2014 | 797 | |
| 2015 | 744 | |
| 2016 | 741 | |
| 2013 | 649 | |
| 2017 | 587 | |
| 2012 | 580 | |
| 2011 | 466 | |
| 2010 | 342 | |
| 2018 | 298 | 5.0% |
| 2009 | 198 | 3.3% |
| Other values (12) | 617 |
| Value | Count | Frequency (%) |
| 1998 | 4 | 0.1% |
| 1999 | 2 | < 0.1% |
| 2000 | 4 | 0.1% |
| 2001 | 8 | 0.1% |
| 2002 | 15 | 0.2% |
| 2003 | 17 | 0.3% |
| 2004 | 31 | 0.5% |
| 2005 | 57 | |
| 2006 | 78 | |
| 2007 | 125 |
| Value | Count | Frequency (%) |
| 2019 | 102 | 1.7% |
| 2018 | 298 | 5.0% |
| 2017 | 587 | |
| 2016 | 741 | |
| 2015 | 744 | |
| 2014 | 797 | |
| 2013 | 649 | |
| 2012 | 580 | |
| 2011 | 466 | |
| 2010 | 342 |
Kilometers_Driven
Real number (ℝ)
High correlation Skewed
| Distinct | 3093 |
|---|---|
| Distinct (%) | 51.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 58738.38 |
| Minimum | 171 |
|---|---|
| Maximum | 6500000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 47.2 KiB |
Quantile statistics
| Minimum | 171 |
|---|---|
| 5-th percentile | 13007.4 |
| Q1 | 34000 |
| median | 53000 |
| Q3 | 73000 |
| 95-th percentile | 120000 |
| Maximum | 6500000 |
| Range | 6499829 |
| Interquartile range (IQR) | 39000 |
Descriptive statistics
| Standard deviation | 91268.843 |
|---|---|
| Coefficient of variation (CV) | 1.5538195 |
| Kurtosis | 4125.0941 |
| Mean | 58738.38 |
| Median Absolute Deviation (MAD) | 19483 |
| Skewness | 58.724662 |
| Sum | 3.5354631 × 108 |
| Variance | 8.3300017 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 60000 | 82 | 1.4% |
| 45000 | 70 | 1.2% |
| 65000 | 68 | 1.1% |
| 50000 | 61 | 1.0% |
| 55000 | 60 | 1.0% |
| 70000 | 60 | 1.0% |
| 30000 | 54 | 0.9% |
| 52000 | 54 | 0.9% |
| 80000 | 50 | 0.8% |
| 75000 | 50 | 0.8% |
| Other values (3083) | 5410 |
| Value | Count | Frequency (%) |
| 171 | 1 | < 0.1% |
| 600 | 1 | < 0.1% |
| 1000 | 9 | |
| 1001 | 2 | < 0.1% |
| 1011 | 1 | < 0.1% |
| 1048 | 1 | < 0.1% |
| 1261 | 1 | < 0.1% |
| 1331 | 1 | < 0.1% |
| 1400 | 1 | < 0.1% |
| 1617 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6500000 | 1 | |
| 775000 | 1 | |
| 720000 | 1 | |
| 620000 | 1 | |
| 480000 | 2 | |
| 445000 | 1 | |
| 300000 | 1 | |
| 299322 | 1 | |
| 282000 | 1 | |
| 262000 | 1 |
Fuel_Type
Categorical
Imbalance
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 47.2 KiB |
| Diesel | |
|---|---|
| Petrol | |
| CNG | 56 |
| LPG | 10 |
| Electric | 2 |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 5.9677687 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CNG |
|---|---|
| 2nd row | Diesel |
| 3rd row | Petrol |
| 4th row | Diesel |
| 5th row | Diesel |
Common Values
| Value | Count | Frequency (%) |
| Diesel | 3205 | |
| Petrol | 2746 | |
| CNG | 56 | 0.9% |
| LPG | 10 | 0.2% |
| Electric | 2 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| diesel | 3205 | |
| petrol | 2746 | |
| cng | 56 | 0.9% |
| lpg | 10 | 0.2% |
| electric | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 9158 | |
| l | 5953 | |
| i | 3207 | 8.9% |
| D | 3205 | 8.9% |
| s | 3205 | 8.9% |
| P | 2756 | 7.7% |
| t | 2748 | 7.7% |
| r | 2748 | 7.7% |
| o | 2746 | 7.6% |
| G | 66 | 0.2% |
| Other values (5) | 128 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 35920 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 9158 | |
| l | 5953 | |
| i | 3207 | 8.9% |
| D | 3205 | 8.9% |
| s | 3205 | 8.9% |
| P | 2756 | 7.7% |
| t | 2748 | 7.7% |
| r | 2748 | 7.7% |
| o | 2746 | 7.6% |
| G | 66 | 0.2% |
| Other values (5) | 128 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 35920 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 9158 | |
| l | 5953 | |
| i | 3207 | 8.9% |
| D | 3205 | 8.9% |
| s | 3205 | 8.9% |
| P | 2756 | 7.7% |
| t | 2748 | 7.7% |
| r | 2748 | 7.7% |
| o | 2746 | 7.6% |
| G | 66 | 0.2% |
| Other values (5) | 128 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 35920 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 9158 | |
| l | 5953 | |
| i | 3207 | 8.9% |
| D | 3205 | 8.9% |
| s | 3205 | 8.9% |
| P | 2756 | 7.7% |
| t | 2748 | 7.7% |
| r | 2748 | 7.7% |
| o | 2746 | 7.6% |
| G | 66 | 0.2% |
| Other values (5) | 128 | 0.4% |
Transmission
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 47.2 KiB |
| Manual | |
|---|---|
| Automatic |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 6.8572853 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Manual |
|---|---|
| 2nd row | Manual |
| 3rd row | Manual |
| 4th row | Manual |
| 5th row | Automatic |
Common Values
| Value | Count | Frequency (%) |
| Manual | 4299 | |
| Automatic | 1720 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| manual | 4299 | |
| automatic | 1720 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 10318 | |
| u | 6019 | |
| M | 4299 | |
| n | 4299 | |
| l | 4299 | |
| t | 3440 | 8.3% |
| A | 1720 | 4.2% |
| o | 1720 | 4.2% |
| m | 1720 | 4.2% |
| i | 1720 | 4.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 41274 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 10318 | |
| u | 6019 | |
| M | 4299 | |
| n | 4299 | |
| l | 4299 | |
| t | 3440 | 8.3% |
| A | 1720 | 4.2% |
| o | 1720 | 4.2% |
| m | 1720 | 4.2% |
| i | 1720 | 4.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 41274 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 10318 | |
| u | 6019 | |
| M | 4299 | |
| n | 4299 | |
| l | 4299 | |
| t | 3440 | 8.3% |
| A | 1720 | 4.2% |
| o | 1720 | 4.2% |
| m | 1720 | 4.2% |
| i | 1720 | 4.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 41274 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 10318 | |
| u | 6019 | |
| M | 4299 | |
| n | 4299 | |
| l | 4299 | |
| t | 3440 | 8.3% |
| A | 1720 | 4.2% |
| o | 1720 | 4.2% |
| m | 1720 | 4.2% |
| i | 1720 | 4.2% |
Owner_Type
Categorical
Imbalance
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 47.2 KiB |
| First | |
|---|---|
| Second | |
| Third | 113 |
| Fourth & Above | 9 |
Length
| Max length | 14 |
|---|---|
| Median length | 5 |
| Mean length | 5.1742814 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | First |
|---|---|
| 2nd row | First |
| 3rd row | First |
| 4th row | First |
| 5th row | Second |
Common Values
| Value | Count | Frequency (%) |
| First | 4929 | |
| Second | 968 | 16.1% |
| Third | 113 | 1.9% |
| Fourth & Above | 9 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| first | 4929 | |
| second | 968 | 16.0% |
| third | 113 | 1.9% |
| fourth | 9 | 0.1% |
| 9 | 0.1% | |
| above | 9 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 5051 | |
| i | 5042 | |
| F | 4938 | |
| t | 4938 | |
| s | 4929 | |
| d | 1081 | 3.5% |
| o | 986 | 3.2% |
| e | 977 | 3.1% |
| S | 968 | 3.1% |
| c | 968 | 3.1% |
| Other values (9) | 1266 | 4.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 31144 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 5051 | |
| i | 5042 | |
| F | 4938 | |
| t | 4938 | |
| s | 4929 | |
| d | 1081 | 3.5% |
| o | 986 | 3.2% |
| e | 977 | 3.1% |
| S | 968 | 3.1% |
| c | 968 | 3.1% |
| Other values (9) | 1266 | 4.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 31144 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 5051 | |
| i | 5042 | |
| F | 4938 | |
| t | 4938 | |
| s | 4929 | |
| d | 1081 | 3.5% |
| o | 986 | 3.2% |
| e | 977 | 3.1% |
| S | 968 | 3.1% |
| c | 968 | 3.1% |
| Other values (9) | 1266 | 4.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 31144 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 5051 | |
| i | 5042 | |
| F | 4938 | |
| t | 4938 | |
| s | 4929 | |
| d | 1081 | 3.5% |
| o | 986 | 3.2% |
| e | 977 | 3.1% |
| S | 968 | 3.1% |
| c | 968 | 3.1% |
| Other values (9) | 1266 | 4.1% |
Mileage
Text
| Distinct | 442 |
|---|---|
| Distinct (%) | 7.3% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 47.2 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 9.3993685 |
| Min length | 8 |
Unique
| Unique | 74 ? |
|---|---|
| Unique (%) | 1.2% |
Sample
| 1st row | 26.6 km/kg |
|---|---|
| 2nd row | 19.67 kmpl |
| 3rd row | 18.2 kmpl |
| 4th row | 20.77 kmpl |
| 5th row | 15.2 kmpl |
| Value | Count | Frequency (%) |
| kmpl | 5951 | |
| 17.0 | 173 | 1.4% |
| 18.9 | 172 | 1.4% |
| 18.6 | 119 | 1.0% |
| 20.36 | 88 | 0.7% |
| 21.1 | 87 | 0.7% |
| 17.8 | 85 | 0.7% |
| 16.0 | 76 | 0.6% |
| 12.8 | 72 | 0.6% |
| 20.0 | 71 | 0.6% |
| Other values (422) | 5140 |
Most occurring characters
| Value | Count | Frequency (%) |
| k | 6083 | |
| . | 6017 | |
| 6017 | ||
| m | 6017 | |
| l | 5951 | |
| p | 5951 | |
| 1 | 5285 | |
| 2 | 3272 | 5.8% |
| 0 | 1860 | 3.3% |
| 7 | 1658 | 2.9% |
| Other values (8) | 8445 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 56556 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| k | 6083 | |
| . | 6017 | |
| 6017 | ||
| m | 6017 | |
| l | 5951 | |
| p | 5951 | |
| 1 | 5285 | |
| 2 | 3272 | 5.8% |
| 0 | 1860 | 3.3% |
| 7 | 1658 | 2.9% |
| Other values (8) | 8445 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 56556 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| k | 6083 | |
| . | 6017 | |
| 6017 | ||
| m | 6017 | |
| l | 5951 | |
| p | 5951 | |
| 1 | 5285 | |
| 2 | 3272 | 5.8% |
| 0 | 1860 | 3.3% |
| 7 | 1658 | 2.9% |
| Other values (8) | 8445 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 56556 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| k | 6083 | |
| . | 6017 | |
| 6017 | ||
| m | 6017 | |
| l | 5951 | |
| p | 5951 | |
| 1 | 5285 | |
| 2 | 3272 | 5.8% |
| 0 | 1860 | 3.3% |
| 7 | 1658 | 2.9% |
| Other values (8) | 8445 |
Engine
Text
| Distinct | 146 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 36 |
| Missing (%) | 0.6% |
| Memory size | 47.2 KiB |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.9015544 |
| Min length | 5 |
Unique
| Unique | 27 ? |
|---|---|
| Unique (%) | 0.5% |
Sample
| 1st row | 998 CC |
|---|---|
| 2nd row | 1582 CC |
| 3rd row | 1199 CC |
| 4th row | 1248 CC |
| 5th row | 1968 CC |
| Value | Count | Frequency (%) |
| cc | 5983 | |
| 1197 | 606 | 5.1% |
| 1248 | 512 | 4.3% |
| 1498 | 304 | 2.5% |
| 998 | 259 | 2.2% |
| 2179 | 240 | 2.0% |
| 1497 | 229 | 1.9% |
| 1198 | 227 | 1.9% |
| 1968 | 216 | 1.8% |
| 1995 | 183 | 1.5% |
| Other values (137) | 3207 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 11966 | |
| 1 | 6169 | |
| 5983 | ||
| 9 | 5477 | |
| 8 | 2498 | 6.0% |
| 4 | 2111 | 5.1% |
| 2 | 2055 | 5.0% |
| 7 | 1714 | 4.2% |
| 6 | 1212 | 2.9% |
| 3 | 943 | 2.3% |
| Other values (2) | 1164 | 2.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 41292 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 11966 | |
| 1 | 6169 | |
| 5983 | ||
| 9 | 5477 | |
| 8 | 2498 | 6.0% |
| 4 | 2111 | 5.1% |
| 2 | 2055 | 5.0% |
| 7 | 1714 | 4.2% |
| 6 | 1212 | 2.9% |
| 3 | 943 | 2.3% |
| Other values (2) | 1164 | 2.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 41292 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 11966 | |
| 1 | 6169 | |
| 5983 | ||
| 9 | 5477 | |
| 8 | 2498 | 6.0% |
| 4 | 2111 | 5.1% |
| 2 | 2055 | 5.0% |
| 7 | 1714 | 4.2% |
| 6 | 1212 | 2.9% |
| 3 | 943 | 2.3% |
| Other values (2) | 1164 | 2.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 41292 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 11966 | |
| 1 | 6169 | |
| 5983 | ||
| 9 | 5477 | |
| 8 | 2498 | 6.0% |
| 4 | 2111 | 5.1% |
| 2 | 2055 | 5.0% |
| 7 | 1714 | 4.2% |
| 6 | 1212 | 2.9% |
| 3 | 943 | 2.3% |
| Other values (2) | 1164 | 2.8% |
Power
Text
| Distinct | 372 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 36 |
| Missing (%) | 0.6% |
| Memory size | 47.2 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 7.9326425 |
| Min length | 6 |
Unique
| Unique | 69 ? |
|---|---|
| Unique (%) | 1.2% |
Sample
| 1st row | 58.16 bhp |
|---|---|
| 2nd row | 126.2 bhp |
| 3rd row | 88.7 bhp |
| 4th row | 88.76 bhp |
| 5th row | 140.8 bhp |
| Value | Count | Frequency (%) |
| bhp | 5983 | |
| 74 | 235 | 2.0% |
| 98.6 | 131 | 1.1% |
| 73.9 | 125 | 1.0% |
| 140 | 123 | 1.0% |
| 78.9 | 111 | 0.9% |
| 67.04 | 107 | 0.9% |
| null | 107 | 0.9% |
| 67.1 | 107 | 0.9% |
| 82 | 101 | 0.8% |
| Other values (363) | 4836 |
Most occurring characters
| Value | Count | Frequency (%) |
| b | 5983 | |
| 5983 | ||
| h | 5983 | |
| p | 5983 | |
| . | 3693 | |
| 1 | 3663 | |
| 8 | 3195 | |
| 7 | 2316 | 4.9% |
| 3 | 1771 | 3.7% |
| 0 | 1721 | 3.6% |
| Other values (8) | 7170 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 47461 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| b | 5983 | |
| 5983 | ||
| h | 5983 | |
| p | 5983 | |
| . | 3693 | |
| 1 | 3663 | |
| 8 | 3195 | |
| 7 | 2316 | 4.9% |
| 3 | 1771 | 3.7% |
| 0 | 1721 | 3.6% |
| Other values (8) | 7170 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 47461 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| b | 5983 | |
| 5983 | ||
| h | 5983 | |
| p | 5983 | |
| . | 3693 | |
| 1 | 3663 | |
| 8 | 3195 | |
| 7 | 2316 | 4.9% |
| 3 | 1771 | 3.7% |
| 0 | 1721 | 3.6% |
| Other values (8) | 7170 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 47461 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| b | 5983 | |
| 5983 | ||
| h | 5983 | |
| p | 5983 | |
| . | 3693 | |
| 1 | 3663 | |
| 8 | 3195 | |
| 7 | 2316 | 4.9% |
| 3 | 1771 | 3.7% |
| 0 | 1721 | 3.6% |
| Other values (8) | 7170 |
Seats
Real number (ℝ)
| Distinct | 9 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 42 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.2787352 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 47.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 5 |
| median | 5 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.80883955 |
|---|---|
| Coefficient of variation (CV) | 0.15322602 |
| Kurtosis | 4.5333633 |
| Mean | 5.2787352 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.8357921 |
| Sum | 31551 |
| Variance | 0.65422143 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 5 | 5014 | |
| 7 | 674 | 11.2% |
| 8 | 134 | 2.2% |
| 4 | 99 | 1.6% |
| 6 | 31 | 0.5% |
| 2 | 16 | 0.3% |
| 10 | 5 | 0.1% |
| 9 | 3 | < 0.1% |
| 0 | 1 | < 0.1% |
| (Missing) | 42 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 2 | 16 | 0.3% |
| 4 | 99 | 1.6% |
| 5 | 5014 | |
| 6 | 31 | 0.5% |
| 7 | 674 | 11.2% |
| 8 | 134 | 2.2% |
| 9 | 3 | < 0.1% |
| 10 | 5 | 0.1% |
| Value | Count | Frequency (%) |
| 10 | 5 | 0.1% |
| 9 | 3 | < 0.1% |
| 8 | 134 | 2.2% |
| 7 | 674 | 11.2% |
| 6 | 31 | 0.5% |
| 5 | 5014 | |
| 4 | 99 | 1.6% |
| 2 | 16 | 0.3% |
| 0 | 1 | < 0.1% |
New_Price
Text
Missing
| Distinct | 540 |
|---|---|
| Distinct (%) | 65.5% |
| Missing | 5195 |
| Missing (%) | 86.3% |
| Memory size | 47.2 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.4332524 |
| Min length | 4 |
Unique
| Unique | 349 ? |
|---|---|
| Unique (%) | 42.4% |
Sample
| 1st row | 8.61 Lakh |
|---|---|
| 2nd row | 21 Lakh |
| 3rd row | 10.65 Lakh |
| 4th row | 32.01 Lakh |
| 5th row | 47.87 Lakh |
| Value | Count | Frequency (%) |
| lakh | 807 | |
| cr | 17 | 1.0% |
| 4.78 | 6 | 0.4% |
| 63.71 | 6 | 0.4% |
| 95.13 | 6 | 0.4% |
| 4.98 | 5 | 0.3% |
| 44.28 | 5 | 0.3% |
| 47.87 | 5 | 0.3% |
| 11.26 | 5 | 0.3% |
| 11.67 | 5 | 0.3% |
| Other values (532) | 781 |
Most occurring characters
| Value | Count | Frequency (%) |
| 824 | ||
| . | 810 | |
| k | 807 | |
| h | 807 | |
| a | 807 | |
| L | 807 | |
| 1 | 518 | 6.7% |
| 4 | 318 | 4.1% |
| 7 | 297 | 3.8% |
| 5 | 294 | 3.8% |
| Other values (8) | 1484 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7773 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 824 | ||
| . | 810 | |
| k | 807 | |
| h | 807 | |
| a | 807 | |
| L | 807 | |
| 1 | 518 | 6.7% |
| 4 | 318 | 4.1% |
| 7 | 297 | 3.8% |
| 5 | 294 | 3.8% |
| Other values (8) | 1484 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7773 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 824 | ||
| . | 810 | |
| k | 807 | |
| h | 807 | |
| a | 807 | |
| L | 807 | |
| 1 | 518 | 6.7% |
| 4 | 318 | 4.1% |
| 7 | 297 | 3.8% |
| 5 | 294 | 3.8% |
| Other values (8) | 1484 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7773 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 824 | ||
| . | 810 | |
| k | 807 | |
| h | 807 | |
| a | 807 | |
| L | 807 | |
| 1 | 518 | 6.7% |
| 4 | 318 | 4.1% |
| 7 | 297 | 3.8% |
| 5 | 294 | 3.8% |
| Other values (8) | 1484 |
Price
Real number (ℝ)
High correlation
| Distinct | 1373 |
|---|---|
| Distinct (%) | 22.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.4794684 |
| Minimum | 0.44 |
|---|---|
| Maximum | 160 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 47.2 KiB |
Quantile statistics
| Minimum | 0.44 |
|---|---|
| 5-th percentile | 1.7 |
| Q1 | 3.5 |
| median | 5.64 |
| Q3 | 9.95 |
| 95-th percentile | 32.446 |
| Maximum | 160 |
| Range | 159.56 |
| Interquartile range (IQR) | 6.45 |
Descriptive statistics
| Standard deviation | 11.187917 |
|---|---|
| Coefficient of variation (CV) | 1.1802262 |
| Kurtosis | 17.092202 |
| Mean | 9.4794684 |
| Median Absolute Deviation (MAD) | 2.62 |
| Skewness | 3.335232 |
| Sum | 57056.92 |
| Variance | 125.16949 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4.5 | 88 | 1.5% |
| 5.5 | 84 | 1.4% |
| 3.5 | 82 | 1.4% |
| 4.25 | 73 | 1.2% |
| 3.25 | 71 | 1.2% |
| 3 | 68 | 1.1% |
| 6.5 | 64 | 1.1% |
| 2.5 | 63 | 1.0% |
| 4 | 56 | 0.9% |
| 4.75 | 53 | 0.9% |
| Other values (1363) | 5317 |
| Value | Count | Frequency (%) |
| 0.44 | 1 | < 0.1% |
| 0.45 | 3 | |
| 0.5 | 2 | |
| 0.51 | 1 | < 0.1% |
| 0.53 | 2 | |
| 0.55 | 3 | |
| 0.6 | 2 | |
| 0.63 | 1 | < 0.1% |
| 0.65 | 2 | |
| 0.69 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 160 | 1 | |
| 120 | 1 | |
| 100 | 1 | |
| 97.07 | 1 | |
| 93.67 | 1 | |
| 93 | 1 | |
| 90 | 1 | |
| 85 | 1 | |
| 83.96 | 1 | |
| 79 | 2 |
Interactions
Correlations
| Fuel_Type | Kilometers_Driven | Location | Owner_Type | Price | Seats | Transmission | Unnamed: 0 | Year | |
|---|---|---|---|---|---|---|---|---|---|
| Fuel_Type | 1.000 | 0.000 | 0.095 | 0.016 | 0.148 | 0.158 | 0.152 | 0.004 | 0.099 |
| Kilometers_Driven | 0.000 | 1.000 | 0.009 | 0.000 | -0.215 | 0.196 | 0.013 | -0.003 | -0.553 |
| Location | 0.095 | 0.009 | 1.000 | 0.161 | 0.074 | 0.020 | 0.184 | 0.000 | 0.139 |
| Owner_Type | 0.016 | 0.000 | 0.161 | 1.000 | 0.058 | 0.035 | 0.013 | 0.000 | 0.250 |
| Price | 0.148 | -0.215 | 0.074 | 0.058 | 1.000 | 0.221 | 0.595 | -0.007 | 0.491 |
| Seats | 0.158 | 0.196 | 0.020 | 0.035 | 0.221 | 1.000 | 0.147 | -0.011 | 0.035 |
| Transmission | 0.152 | 0.013 | 0.184 | 0.013 | 0.595 | 0.147 | 1.000 | 0.023 | 0.096 |
| Unnamed: 0 | 0.004 | -0.003 | 0.000 | 0.000 | -0.007 | -0.011 | 0.023 | 1.000 | 0.009 |
| Year | 0.099 | -0.553 | 0.139 | 0.250 | 0.491 | 0.035 | 0.096 | 0.009 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| Unnamed: 0 | Name | Location | Year | Kilometers_Driven | Fuel_Type | Transmission | Owner_Type | Mileage | Engine | Power | Seats | New_Price | Price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | Maruti Wagon R LXI CNG | Mumbai | 2010 | 72000 | CNG | Manual | First | 26.6 km/kg | 998 CC | 58.16 bhp | 5.0 | NaN | 1.8 |
| 1 | 1 | Hyundai Creta 1.6 CRDi SX Option | Pune | 2015 | 41000 | Diesel | Manual | First | 19.67 kmpl | 1582 CC | 126.2 bhp | 5.0 | NaN | 12.5 |
| 2 | 2 | Honda Jazz V | Chennai | 2011 | 46000 | Petrol | Manual | First | 18.2 kmpl | 1199 CC | 88.7 bhp | 5.0 | 8.61 Lakh | 4.5 |
| 3 | 3 | Maruti Ertiga VDI | Chennai | 2012 | 87000 | Diesel | Manual | First | 20.77 kmpl | 1248 CC | 88.76 bhp | 7.0 | NaN | 6.0 |
| 4 | 4 | Audi A4 New 2.0 TDI Multitronic | Coimbatore | 2013 | 40670 | Diesel | Automatic | Second | 15.2 kmpl | 1968 CC | 140.8 bhp | 5.0 | NaN | 17.7 |
| 5 | 5 | Hyundai EON LPG Era Plus Option | Hyderabad | 2012 | 75000 | LPG | Manual | First | 21.1 km/kg | 814 CC | 55.2 bhp | 5.0 | NaN | 2.4 |
| 6 | 6 | Nissan Micra Diesel XV | Jaipur | 2013 | 86999 | Diesel | Manual | First | 23.08 kmpl | 1461 CC | 63.1 bhp | 5.0 | NaN | 3.5 |
| 7 | 7 | Toyota Innova Crysta 2.8 GX AT 8S | Mumbai | 2016 | 36000 | Diesel | Automatic | First | 11.36 kmpl | 2755 CC | 171.5 bhp | 8.0 | 21 Lakh | 17.5 |
| 8 | 8 | Volkswagen Vento Diesel Comfortline | Pune | 2013 | 64430 | Diesel | Manual | First | 20.54 kmpl | 1598 CC | 103.6 bhp | 5.0 | NaN | 5.2 |
| 9 | 9 | Tata Indica Vista Quadrajet LS | Chennai | 2012 | 65932 | Diesel | Manual | Second | 22.3 kmpl | 1248 CC | 74 bhp | 5.0 | NaN | 1.9 |
| Unnamed: 0 | Name | Location | Year | Kilometers_Driven | Fuel_Type | Transmission | Owner_Type | Mileage | Engine | Power | Seats | New_Price | Price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6009 | 6009 | Toyota Camry Hybrid | Mumbai | 2015 | 33500 | Petrol | Automatic | First | 19.16 kmpl | 2494 CC | 158.2 bhp | 5.0 | NaN | 19.8 |
| 6010 | 6010 | Honda Brio 1.2 VX MT | Delhi | 2013 | 33746 | Petrol | Manual | First | 18.5 kmpl | 1198 CC | 86.8 bhp | 5.0 | 6.63 Lakh | 3.2 |
| 6011 | 6011 | Skoda Superb 3.6 V6 FSI | Hyderabad | 2009 | 53000 | Petrol | Automatic | First | 0.0 kmpl | 3597 CC | 262.6 bhp | 5.0 | NaN | 4.8 |
| 6012 | 6012 | Toyota Innova 2.5 V Diesel 7-seater | Coimbatore | 2011 | 45004 | Diesel | Manual | First | 12.8 kmpl | 2494 CC | 102 bhp | 7.0 | NaN | 9.5 |
| 6013 | 6013 | Honda Amaze VX i-DTEC | Coimbatore | 2015 | 70602 | Diesel | Manual | First | 25.8 kmpl | 1498 CC | 98.6 bhp | 5.0 | NaN | 4.8 |
| 6014 | 6014 | Maruti Swift VDI | Delhi | 2014 | 27365 | Diesel | Manual | First | 28.4 kmpl | 1248 CC | 74 bhp | 5.0 | 7.88 Lakh | 4.8 |
| 6015 | 6015 | Hyundai Xcent 1.1 CRDi S | Jaipur | 2015 | 100000 | Diesel | Manual | First | 24.4 kmpl | 1120 CC | 71 bhp | 5.0 | NaN | 4.0 |
| 6016 | 6016 | Mahindra Xylo D4 BSIV | Jaipur | 2012 | 55000 | Diesel | Manual | Second | 14.0 kmpl | 2498 CC | 112 bhp | 8.0 | NaN | 2.9 |
| 6017 | 6017 | Maruti Wagon R VXI | Kolkata | 2013 | 46000 | Petrol | Manual | First | 18.9 kmpl | 998 CC | 67.1 bhp | 5.0 | NaN | 2.6 |
| 6018 | 6018 | Chevrolet Beat Diesel | Hyderabad | 2011 | 47000 | Diesel | Manual | First | 25.44 kmpl | 936 CC | 57.6 bhp | 5.0 | NaN | 2.5 |